package com.huabo.system.oracle.mapper;

import com.huabo.system.oracle.entity.TblAcquisitionRecord;
import com.huabo.system.oracle.entity.TblImplog;
import com.hbfk.util.PageInfo;

import java.math.BigDecimal;

public class TblImplogMapperSqlConfig {


	public String findByTblImplogList(PageInfo<TblImplog> pageInfo, String username, String type) {

		StringBuffer sqlSb = new StringBuffer("SELECT * FROM (SELECT BUDGET.*,ROWNUM RN FROM (SELECT * FROM TBL_IMP_LOG  WHERE IMPTYPE = '"+type+ "' and IMPCREATEUSERNAME = '"+username+"' ");
		sqlSb.append(" order by IMPCREATETIME desc ) BUDGET WHERE rownum <= "+(pageInfo.getCurrentPage()*pageInfo.getPageSize())+" ) WHERE RN > "+pageInfo.getCurrentRecord());
		String sql = sqlSb.toString();
		return sql;
	}
}
